﻿/*
LICENCE___________________________________________________________________
    Copyright (C) 2012 Reverdy Sylvain

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License along
    with this program; if not, write to the Free Software Foundation, Inc.,
    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
FIN LICENCE______________________________________________________________
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Merise_designer.Donnees
{
    class Types
    {
        private CL_CAD cad = new CL_CAD();

        public void add(string nom)
        {
            string req = @"INSERT INTO TYPES (NOM_TYPE) VALUES('" + nom + "')";
            cad.ActionsRows(req, true);
        }

        public void update(string id, string nom)
        {
            string req = @"UPDATE TYPES SET NOM_TYPE='" + nom + "' WHERE ID_TYPE='" + id + "'";
            cad.ActionsRows(req, true);
        }

        public void deleteAll()
        {
            string req = @"DELETE FROM TYPES";
            cad.ActionsRows(req, true);
        }

        public void delete(string id)
        {
            string req = @"DELETE FROM TYPES WHERE ID_TYPE='" + id + "'";
            cad.ActionsRows(req, true);
        }

        public DataSet selectAll(string monJeu)
        {
            string req = @"SELECT ID_TYPE, NOM_TYPE FROM TYPES";
            return cad.GetRows(req, monJeu);
        }

        //public DataSet select(string id, string monJeu)
        //{
        //    string req = @"SELECT ID_TYPE, NOM_TYPE FROM TYPES WHERE ID_TYPE='" + id + "'";
        //    return cad.GetRows(req, monJeu);
        //}


    }
}
